UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PaIMWb7GCP2fciRtvfyxuLBkKYM9i6UbRsmkIbnFCcU='
WHERE
key_id = 'e4dadd1ffc32aa755423347722297cfad50a94d07f0e9a8ab89da32292a9e859'
AND (
token = 'PaIMWb7GCP2fciRtvfyxuLBkKYM9i6UbRsmkIbnFCcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)