UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e/GsW2YEEae8qf569Ni93d3Xlz2VblVcGSHiOGgy4h0='
WHERE
key_id = '29a2e5491150b79bcfe404a291197883b63c1d95cf8cd8402b584535b7bc1944'
AND (
token = 'e/GsW2YEEae8qf569Ni93d3Xlz2VblVcGSHiOGgy4h0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)