UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4sPGCIVC/SZQF9pPFez60hu8O9WAboJm2S1m6hYvOg0='
WHERE
key_id = 'bd8ca989f88cfb167f6b2b1407234cce68dff2495cc9a4f6d2840e872d97168e'
AND (
token = '4sPGCIVC/SZQF9pPFez60hu8O9WAboJm2S1m6hYvOg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)