UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DvIBqfG7jmwHNK8w/Iox8R+Ss8JHGNhms6o+QEwCdXY='
WHERE
key_id = 'ecfdb6e53d0e6999a41b88217a219c151dd7cee17e5cae86b0fa2bd92da2aa98'
AND (
token = 'DvIBqfG7jmwHNK8w/Iox8R+Ss8JHGNhms6o+QEwCdXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)