UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wR8hCuGdZgl9jz7bfncB8TN3nCtWDcERdtGWI4/TEV8='
WHERE
key_id = 'e96e79eeee50ed767206ca297c4f8c888827b4e4446cb78be6492887924a3a53'
AND (
token = 'wR8hCuGdZgl9jz7bfncB8TN3nCtWDcERdtGWI4/TEV8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)