UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8O7QjnL247F9T6q5xzj6baBvsuBCaL1Z8YOopubchPI='
WHERE
key_id = 'e5c9c35d99430ac317031ac41a87c9be3f8a3db224993ffe5cd1adaecc6adef6'
AND (
token = '8O7QjnL247F9T6q5xzj6baBvsuBCaL1Z8YOopubchPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)