UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pCoI5pultKznKTxZYEG+QfbtcomKCd/ffb4d5kzMACw='
WHERE
key_id = '08c1a47a8ccde4f5f93f6d91e85a1a991311a7b97bc82d2c361e33363be2911b'
AND (
token = 'pCoI5pultKznKTxZYEG+QfbtcomKCd/ffb4d5kzMACw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)