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