UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tel8U0fy++XCtvjMOFbmmWPm/nLjSC3az1Hs3G4P60g='
WHERE
key_id = 'bb4b831fd584f1ffcdb262e698ca47ae546acdfde3152645cb49fb47efd79338'
AND (
token = 'tel8U0fy++XCtvjMOFbmmWPm/nLjSC3az1Hs3G4P60g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)