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