UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r4X/ypSBXItrZMxKU1ksU9xx47D4YaA5IUfo9sDDyn8='
WHERE
key_id = 'e164d8f65dfdf77e73455b66eda96575d5d35b0a50dba0c3509c3b309190ceba'
AND (
token = 'r4X/ypSBXItrZMxKU1ksU9xx47D4YaA5IUfo9sDDyn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)