UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5xQTq09aTDWerYO+Mx5VDol1McIEyKriw1ERvRw+utU='
WHERE
key_id = 'bef40eee5dc84d972d37f361d96fba9e540d986019084f0facdae13e0d840874'
AND (
token = '5xQTq09aTDWerYO+Mx5VDol1McIEyKriw1ERvRw+utU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)