UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VW02+1lbdImJ9xHszQf0JOwGugjGOi3gGbJ28XAXSwg='
WHERE
key_id = '849a862a8417e636f3beabd9c89cf45ad3fb715b91debe84307d516f7cd32230'
AND (
token = 'VW02+1lbdImJ9xHszQf0JOwGugjGOi3gGbJ28XAXSwg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)