UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'loBvqNtDUqY8DD88GNaLrZxWYW4O0AzrvLty2ZZvwu4='
WHERE
key_id = 'dca1c7e2658cca51714515b07cbc4db4e03856cb5cbd9b141bfc8a0542bf4f52'
AND (
token = 'loBvqNtDUqY8DD88GNaLrZxWYW4O0AzrvLty2ZZvwu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)