UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xwQrICogy2et9INZkuHiLiqGqjIhMoOIrv2g6t4n+HE='
WHERE
key_id = 'bea60dad725386305de56da6b6fba0f2f949f00ce42fe56c7afa989f0b3573fb'
AND (
token = 'xwQrICogy2et9INZkuHiLiqGqjIhMoOIrv2g6t4n+HE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)