UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8Q57p6GD38sEtYetuDCgAOGXvKYDGi56ZgHDJDG4+xU='
WHERE
key_id = '0e5661ce0e16550b9997ba734901f0c7331e449661615f7697397cd1710e52f3'
AND (
token = '8Q57p6GD38sEtYetuDCgAOGXvKYDGi56ZgHDJDG4+xU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)