UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uBW/SspjVS0fgziJuhbZhIkyojyfH4FaYJh0QF0CzHU='
WHERE
key_id = 'da4f92c83931180f52d213d622707e938ba05e9f36f64cf76f3e029527448abc'
AND (
token = 'uBW/SspjVS0fgziJuhbZhIkyojyfH4FaYJh0QF0CzHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)