UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aiVrnkYe72Nb1RWATX6bJ3ZVbHG7+IFAj+jOw7eBfkU='
WHERE
key_id = '3ac03ece096d9b422418eacb8f1849704e2c13e78a35c9fc992b6ddf9dc532c9'
AND (
token = 'aiVrnkYe72Nb1RWATX6bJ3ZVbHG7+IFAj+jOw7eBfkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)