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