UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5CNxxAJ5qkph3uW7leXPXTPwC7BUbs1wCv+p4PihkM='
WHERE
key_id = 'a70716b6daac921dcf94239a5579c6484eef5845cd5ad9088dc7a8362998a2e7'
AND (
token = 'G5CNxxAJ5qkph3uW7leXPXTPwC7BUbs1wCv+p4PihkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)