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