UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NTgbR+e4E3yrYjcnj+dI6RkPZib0gIwctu9wOPxnIYk='
WHERE
key_id = 'e9dc24334151c3070938f19e0c3139d987235b64f7df4b1e91d3beeefa7a6d34'
AND (
token = 'NTgbR+e4E3yrYjcnj+dI6RkPZib0gIwctu9wOPxnIYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)