UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vzjA3MDHxoCzgLaBU3U9cj0TxqYxcpVvjUi/1dxpxqk='
WHERE
key_id = 'a43a4fb21564dbb72ca7590972facb4f032a1fcd7c9da3b22e8febdb1567bfa8'
AND (
token = 'vzjA3MDHxoCzgLaBU3U9cj0TxqYxcpVvjUi/1dxpxqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)