UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SdI47+872ZAPdpQ06qH1Q3x1LOYUfpfHETR4VfWX2kE='
WHERE
key_id = '3e6ed11939efd20171dffd62e51e837f7b39504f3fe39b15c44a327d39a4dd70'
AND (
token = 'SdI47+872ZAPdpQ06qH1Q3x1LOYUfpfHETR4VfWX2kE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)