UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idNpjuKrfEc0VqAKbhtVwUWsqvPQKT9wM/ScyZmxQyk='
WHERE
key_id = 'c734e8d3a956ec341ca291a822dbf002f3d63c3c3d2e2a18610a33dc41b36cf8'
AND (
token = 'idNpjuKrfEc0VqAKbhtVwUWsqvPQKT9wM/ScyZmxQyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)