UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p4jZUnJ3KuM3u3W3mxkPgfGk6IRaKxenV1wO3YXyRMI='
WHERE
key_id = '1e9b74d2d3c0a8f7e528273a50565af5da69ff26902c01cb8a604d0f48c55483'
AND (
token = 'p4jZUnJ3KuM3u3W3mxkPgfGk6IRaKxenV1wO3YXyRMI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)