UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qi8m81MR/9wx89qDF/E6b+dDUzjwq5kMAokbvnLRB0E='
WHERE
key_id = '06f818c381bea64b8f40da6e82ae36b571af26a59843b92675c8cfc91d7192d8'
AND (
token = 'qi8m81MR/9wx89qDF/E6b+dDUzjwq5kMAokbvnLRB0E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)