UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6oCtJ/Vn05vDsz01B43Yx7m6KYKV/NkHlquTvAVjBMU='
WHERE
key_id = '4c1881c1af9093abfb83d913ee4dd243000d31363b98177270ed3fc7c7988cfc'
AND (
token = '6oCtJ/Vn05vDsz01B43Yx7m6KYKV/NkHlquTvAVjBMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)