UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7L8gs8+oUTWDiM7Zt9vO+jeYHi+5fpghR/EXwuKmYU='
WHERE
key_id = '31ff300e470ce71bb2b3a166ce7a406dbcfa6abda2046f4b500498bbd165af67'
AND (
token = 'e7L8gs8+oUTWDiM7Zt9vO+jeYHi+5fpghR/EXwuKmYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)