UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8N3QEBToeQLh/63wU+mhd4oYbmAg2hldw07JgGnklj4='
WHERE
key_id = 'a5d16d75ed65f36742eb1eae264215e1281c623a7daca7ea7964626cefa97a24'
AND (
token = '8N3QEBToeQLh/63wU+mhd4oYbmAg2hldw07JgGnklj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)