UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LXbwBWDxR3ys1ZzuFG7G5CY1oBozfeWLkZcY/uygPr0='
WHERE
key_id = '7e7aeb88e0adbc50516be1a5d62befbfa99e6b4030cd8ffb5ac003b7b673aec2'
AND (
token = 'LXbwBWDxR3ys1ZzuFG7G5CY1oBozfeWLkZcY/uygPr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)