UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U2tUgHM1UEWbDtff1WM4wLVH/tmF7tmwTK4M6R/evWY='
WHERE
key_id = 'edfac8507e86ffa31bee7fdcdcf99ea97fbb409f05c7ae44b5241172923e0cbf'
AND (
token = 'U2tUgHM1UEWbDtff1WM4wLVH/tmF7tmwTK4M6R/evWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)