UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dhgfir0zjD+2ikaKTvpnBtd1PIQtgr93walzbXNFC10='
WHERE
key_id = 'bd01520d7370aa29ebfe03c3eec1ebdbd961354482c86a842d62528e96ef281b'
AND (
token = 'dhgfir0zjD+2ikaKTvpnBtd1PIQtgr93walzbXNFC10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)