UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nupaxDujKttD+oIMS+IVL9IlJXAJr2a6Pyf7bKq/oCE='
WHERE
key_id = 'b3f65e4c63b517b1345ef4580f9468fbdbc41e574092e8b1de9b2c75e7e90e1a'
AND (
token = 'nupaxDujKttD+oIMS+IVL9IlJXAJr2a6Pyf7bKq/oCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)