UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnE2VaixY+aibCNDAW5AgOIzgMnf4NUti1qGacZqYUU='
WHERE
key_id = 'dbc7ca5986a3bbaf852386eaa8854255295b8c7720e392fd6890079df3e3b650'
AND (
token = 'nnE2VaixY+aibCNDAW5AgOIzgMnf4NUti1qGacZqYUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)