UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gC63hTlbsC0h2Gnxab6c0VOxegqN6mQUr3phwvcchs='
WHERE
key_id = 'ed239e152f6f82caec0a4a05d652485f08927c60d791788d9db3b091854cae33'
AND (
token = '6gC63hTlbsC0h2Gnxab6c0VOxegqN6mQUr3phwvcchs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)