UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcKLgtSuVBGEbULRh7ETYhwCKJK2s9lBsD6CMRL2Hhg='
WHERE
key_id = '38a84b46a3cf63bd67cb8f98e80676dfaa1ac60620872896c9eab98487ee6b69'
AND (
token = 'mcKLgtSuVBGEbULRh7ETYhwCKJK2s9lBsD6CMRL2Hhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)