UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3oZySDk+NkCTe3UgVJ1RliNHrFw4/mCgb1+59Re0+Tc='
WHERE
key_id = 'c8cd8fcd53b7100568b15de23bf777fc69fecce0071c1cf1493093064578b2f2'
AND (
token = '3oZySDk+NkCTe3UgVJ1RliNHrFw4/mCgb1+59Re0+Tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)