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