UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CzdA2Wm/y1i9MJtiNRgmI9XhYm10Gi8p6j6SpiFwtmE='
WHERE
key_id = 'bf74d3fc3da001deb4260fb3afa09e5a3dc1bac0fc450c7b042c626aa4c8e442'
AND (
token = 'CzdA2Wm/y1i9MJtiNRgmI9XhYm10Gi8p6j6SpiFwtmE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)