UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pOqWcwyi2xqIuerB2mCfTEvySAtfFNo1M7TEYs8TWzA='
WHERE
key_id = '4a007eed552918538bebe8c85040995fdc69ddaa9a1088e7bb2713dc6cc038ac'
AND (
token = 'pOqWcwyi2xqIuerB2mCfTEvySAtfFNo1M7TEYs8TWzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)