UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XyPn9jd153XzXaIubi6thWne0R3BJfxnbRVPV7CWMqE='
WHERE
key_id = '6c11234cc80e3dcd62b8bcbc56cad9f9a32197dc48a34841f4a875a1378886b2'
AND (
token = 'XyPn9jd153XzXaIubi6thWne0R3BJfxnbRVPV7CWMqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)