UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8DrpEG6WCsHOY+P26J+0yoNY82sAMBiVUhlzs1q1yvA='
WHERE
key_id = 'f24c2e946a39c1b38a722462671a09e5fe67c369388b32b345328810e65e607c'
AND (
token = '8DrpEG6WCsHOY+P26J+0yoNY82sAMBiVUhlzs1q1yvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)