UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2RC8IA3L546KuBrXx/7mFBCDISikOoTMUq26bMKFh4='
WHERE
key_id = '77d0639199e68a72954fb0f4756b02a29eb620fe7ffe8fb9d4763fd0de82c5d0'
AND (
token = 'z2RC8IA3L546KuBrXx/7mFBCDISikOoTMUq26bMKFh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)