UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YRZmHlBovr5GtmLWweTearVCj41rCv3fu7qOEU9L7a0='
WHERE
key_id = 'bb943d581335ae4ba1e29d97a290131033ecd7a9b98290526abba11eff840881'
AND (
token = 'YRZmHlBovr5GtmLWweTearVCj41rCv3fu7qOEU9L7a0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)